<?php
/* wwwschool project

Copyright (C) 2009  Phillip Aldridge
Email : info@imi21.com
Web site http://www.imi21.com

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/


/**
 *  File : updateAddress.php
 *  called only via ajax 
 *  
 *  requires POST  op, id
 */  

//$$TODO Who is allowed to edit this
$date=date("Y-m-d H:i:s");

$function2=$_POST['function2']; // which function to call after update
$param1=$_POST['param1'];//  // which function to call after update



$id=$_POST['id'];
$street1=$_POST['street1'];
$street2=$_POST['street2'];
$town=$_POST['town'];
$country=$_POST['country'];
$postcode=$_POST['postcode']; 

$db=new WS3_Database();
$q="SELECT `id`,`user_id` FROM `addressbook` WHERE 1 AND `id`= '$id' LIMIT 1";

  
if ($db->query($q) && $db->nextRecord() )
{ // user does exisits
  $user_id=$db->f('user_id');
  
  $db2=new WS3_Database();
  
  $q="UPDATE `addressbook` SET
  `date_modified`='$date',
  `street1`='$street1',
  `street2`='$street2',
  `town`='$town',
  `country`='$country',
  `postcode`='$postcode'
  WHERE  `id`='$id' LIMIT 1";

  
  if ($db2->query($q)){
   if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"update ok id");
  }else{
    if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"update failed id");
  }
}else{
    if (W3DEBUG) array_push($GLOBALS['W3DEBUG'],"user not found id");
}
  
  

$db=new WS3_Database();
$q="SELECT user_type FROM `user` WHERE 1 AND `id`= '$user_id' LIMIT 1";


if ($db->query($q) && $db->nextRecord() )
{
$_POST['level']=$db->f('user_type');
include 'listUsers.php';

}

?>